USE PayrollRedux

if not exists (select * from master.dbo.syslogins where loginname = N'bob')
BEGIN
	CREATE LOGIN bob WITH PASSWORD = 'martin',       CHECK_POLICY = OFF
END



exec sp_grantdbaccess 'bob'

exec sp_addrolemember 'db_owner', 'bob'